﻿using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Support
{
    public interface SQL
    {
        void connect(string host, string username, string password, string database);
        void disconnect();
        void insertDataObject(int type, int FileSize, byte[] rawData, string name, int album);
        DataSet getSession(string sessionID);
        DataSet getDataObject(int objectID);
        DataSet getAlbumContent(int albumID);
        void createUserTable();
        void insertSession(string sessionID, byte[] keyBytes);
        DataSet getUser(string userName);
        void updateSession(string sessionID, string DBtype, string DBurl, string DBuser, string DBpassword, string DBname);
        void updateTimestamp(string sessionID);
        void removeExpiredSessions();
        void deleteAlbumContent(int albumID);
        void deleteDataObject(int id);
        void updateLocation(int id, int album);
        void updateName(int id, string name);
        DataSet checkPictureTableExistance(string database);
        void createRoot();
    }
}
